A Step towards Centralized Data Warehousing Process: A Quality Aware Data Warehouse Architecture

Data Warehouse is becoming more and more popular by providing business an edge over their competitors. DW is developed by using DWP methodology. Currently, there are large numbers of methodologies followed in market. The reason for this is the lack of any centralized attempts of creating platform-independent DWP standards. For developing a centralized DWP it is important to understand the existing methodologies. The authors have done a comparison of five well known methodologies and highlighted the similarities between the processes they used. A new DW architecture has been proposed by integrating those similar processes. This new architecture concentrates mainly on the quality of the DW, as it is one of the critical aspects of DW. Quality is being introduced by defining 3 new components named as quality control, DW monitor, DW Integration Change Management. Evolution of metadata and DW repository are the most important tasks of the quality management.